﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Animation;
using System.Windows.Shapes;
using ESRI.ArcGIS.Client;
using ESRI.ArcGIS.Client.Symbols;
using ESRI.ArcGIS.Client.Geometry;
namespace Silverlight.Arcgis.MapTip
{
    using Skybot.Arcgis.Client.TileLayerExpand;
    using ESRI.ArcGIS.Client.Bing;
    using System.Text;
    public partial class 加载线路与轨迹 : UserControl
    {
        /// <summary>
        /// JS数据
        /// </summary>
        Silverlight.Arcgis.MapTip.GetDate.JsonGetData JsData = new Silverlight.Arcgis.MapTip.GetDate.JsonGetData();

        /// <summary>
        /// 添加到地图的画管理类
        /// </summary>
        Silverlight.Arcgis.MapTip.DataEntity.ObjectListManager<Graphic> graphicManager = new Silverlight.Arcgis.MapTip.DataEntity.ObjectListManager<Graphic>();

        /// <summary>
        /// Envelop 值对像用于邦定
        /// </summary>
        Silverlight.Arcgis.MapTip.DataEntity.EnvelopValue envelopValue = new Silverlight.Arcgis.MapTip.DataEntity.EnvelopValue();

        /// <summary>
        /// 原素图层
        /// </summary>
        ElementLayer layElementLayer = null;

        /// <summary>
        /// 点
        /// </summary>
        Envelope envelop = new Envelope();

        bool 开始画点了 = false;

        #region 显示数据

        /// <summary>
        /// 初始化画图的图层
        /// </summary>
        GraphicsLayer GraphicLayer = null;

        /// <summary>
        /// 画笔
        /// </summary>
        Draw draw画笔 = null;


        #endregion

        public 加载线路与轨迹()
        {
            InitializeComponent();

            //属性值改变事件
            JsData.PropertyChanged += new System.ComponentModel.PropertyChangedEventHandler(JsData_PropertyChanged);
            
            TileLayerBingMapExpand layer =new TileLayerBingMapExpand(new Uri("http://192.168.58.90:8456/tiles/a{quadkey}.png?g=49"),
        16, 1);

            
           
            layer.LayerStyle = TileLayerBingMapExpand.LayerType.Aerial;
             //加载完成后的事件
            layer.Initialized += new EventHandler<EventArgs>(layer_Initialized);

            ///MapObj.Layers.Insert(0, layer);
            在地图上画线();

            
        }
        /// <summary>
        /// 加载完成后的事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void layer_Initialized(object sender, EventArgs e)
        {
            //一定要先移动一下 不然会有错位发生
            MapObj.ZoomTo(new ESRI.ArcGIS.Client.Geometry.Envelope(
               new MapPoint(121.2890625, 31.353636941500987)
               ,
               new MapPoint(121.640625, 31.052933985705138)
               ));

            System.Windows.Threading.DispatcherTimer timer = new System.Windows.Threading.DispatcherTimer();
            timer.Interval = TimeSpan.FromMilliseconds(200);
            timer.Tick += (s,ev) => {
                timer.Stop();
                ((TileLayerBingMapExpand)sender).LayerStyle = TileLayerBingMapExpand.LayerType.Road;
                ///得到当前的数据
                JsData.GetDate(new Uri(System.Windows.Browser.HtmlPage.Document.DocumentUri.Scheme + "://" + System.Windows.Browser.HtmlPage.Document.DocumentUri.Host + ":" + System.Windows.Browser.HtmlPage.Document.DocumentUri.Port + "/LineBackJsonDataSource.txt?" + Guid.NewGuid().ToString()));

                timer = null;
            };
            timer.Start();
          

        }



        /// <summary>
        /// 属性值改变事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void JsData_PropertyChanged(object sender, System.ComponentModel.PropertyChangedEventArgs e)
        {
            //下载数据
            if (e.PropertyName == "Progerss")
            {
                Dispatcher.BeginInvoke(new Action(
                    () =>
                    {

                        prog.Value = JsData.Progerss;

                        tt.Text = "下载数据:" + JsData.Progerss + "%";
                    }));
            }

            //属性名 
            if (e.PropertyName == "DataCurrProgerss")
            {
                Dispatcher.BeginInvoke(new Action(
                    () =>
                    {
                        if (JsData.DataCount > 0)
                        {
                            prog.Value = (JsData.DataCurrProgerss / JsData.DataCount) * 100;
                        }
                        tt.Text = "正在处理数据:" + JsData.DataCount + "/" + JsData.DataCurrProgerss;



                    }));
            }

            //属性名 
            if (e.PropertyName == "Data")
            {

            }



        }


        #region 在地图上画线

        /// <summary>
        /// 在地图上画线
        /// </summary>
        void 在地图上画线()
        {
            //初始化变量 
            GraphicLayer = MapObj.Layers["画图的图层"] as GraphicsLayer;

            //初始化原素图层
            layElementLayer = MapObj.Layers["原素图层"] as ElementLayer;

            #region 创建一个关联的图但是图片不会跟着跑

            RecElementLayer = layElementLayer.Children.First(p => ((FrameworkElement)p).Name == "RecElementLayer") as TextBlock;

            //关联数据
            RecElementLayer.SetBinding(ElementLayer.EnvelopeProperty, new System.Windows.Data.Binding("Envelope")
            {
                Source = envelopValue,
                Mode = System.Windows.Data.BindingMode.OneWay,
            });
            #endregion


            

          



            draw画笔 = new Draw(MapObj)
            {
                LineSymbol = new LineSymbol()
                {
                    Color = new SolidColorBrush(Colors.Red),
                    Width = 2
                },
                FillSymbol = new SimpleFillSymbol()
                {
                    BorderBrush = new SolidColorBrush(Colors.Red) { },
                    BorderThickness = 2,
                    Fill = new SolidColorBrush(Colors.Green) { Opacity = 0.5 }
                },
                //设定画的线
                DrawMode = DrawMode.Polyline,

            };

            //激活绘图工具
            draw画笔.IsEnabled = false;

            #region 注册画图的事件



            #endregion


            //注册事件
            draw画笔.DrawComplete += new EventHandler<DrawEventArgs>(draw画笔_DrawComplete);

        }

        /// <summary>
        /// 画图完成
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void draw画笔_DrawComplete(object sender, DrawEventArgs e)
        {
            //PointColl.Add(new MapPoint(121.587785, 31.0880583333333));
            //PointColl.Add(new MapPoint(120.587783333333, 30.08806));
            //使用线程来操作
            //System.Threading.Thread Thr = new System.Threading.Thread( new System.Threading.ThreadStart());

            //开始
            //Thr.Start();

        }

        /// <summary>
        /// 画指定记录的线
        /// </summary>
        /// <param name="i">指定的记录</param>
        void 画单条线的方法(int i)
        {

            MapPoint Stra = null;
            MapPoint End = null;
            得到指定记录的点(i, ref Stra, ref End);
            Stra = Stra;
            End = End;
            画线(i,Stra, End);

            //创建一个
            envelopValue.Envelope.XMax = End.Extent.XMax;
            envelopValue.Envelope.XMin = End.Extent.XMin;
            envelopValue.Envelope.YMax = End.Extent.YMax;
            envelopValue.Envelope.YMin = End.Extent.YMin;
            


            ///进行移动的接口
            {
                Point CurrCarpoint = MapObj.MapToScreen(new MapPoint(End.X, End.Y));

                Rec.SetValue(Canvas.TopProperty, CurrCarpoint.Y);
                Rec.SetValue(Canvas.LeftProperty, CurrCarpoint.X);
            }

            //看看当前的点在地图的范围里
            if (End.X <= MapObj.Extent.XMax
                &&
               End.Y <= MapObj.Extent.YMax
                &&
                End.X >= MapObj.Extent.XMin
                &&
               End.Y >= MapObj.Extent.YMin
                )
            {

            }
            else
            {
                //MapObj.ScreenToMap(new Point(End.X, End.Y));
                //如果不在范围内
                MapObj.PanTo(new MapPoint(End.X, End.Y));
            }
        }

        /// <summary>
        /// 删除指定记录的线
        /// </summary>
        /// <param name="i">指定的记录</param>
        void 删除单条线的方法(int i)
        {
            //声明一个临时的变量
            Graphic tempGraphic = null;


            try
            {
                //得到当前的线
                 tempGraphic = GraphicLayer.Graphics.First(p => p.Geometry.SpatialReference.WKID == i);
            }
                //没有找到数据
            catch (InvalidOperationException)
            {
                return;  
            }
            //显示数据
            ESRI.ArcGIS.Client.Geometry.Polyline  templine = tempGraphic .Geometry as ESRI.ArcGIS.Client.Geometry.Polyline;

            MapPoint Stra = templine.Paths[0][0];
            MapPoint End = templine.Paths[0][1];

            //看看当前的点在地图的范围里
            if (End.X <= MapObj.Extent.XMax
                &&
              End.Y <= MapObj.Extent.YMax
                &&
                End.X >= MapObj.Extent.XMin
                &&
               End.Y >= MapObj.Extent.YMin
                )
            {

            }
            else
            {
                //MapObj.ScreenToMap(new Point(End.X, End.Y));
                //如果不在范围内
                MapObj.PanTo(new MapPoint(End.X, End.Y));
            }

            //删除线
            GraphicLayer.Graphics.Remove(tempGraphic);
        }


        /// <summary>
        /// 得到指定记录的点
        /// </summary>
        /// <param name="i">要得到记录的位置</param>
        /// <param name="SPoint">起点对像</param>
        /// <param name="EPoint">终点对像</param>
        void 得到指定记录的点(int i, ref MapPoint SPoint, ref MapPoint EPoint)
        {
            System.Json.JsonValue JsValue = (System.Json.JsonValue)JsData.Data;
            MapPoint Stra;
            MapPoint End;
            double X = 0;
            double Y = 0;
            double XX = 0;
            double YY = 0;
            foreach (var p in ((System.Json.JsonObject)JsValue[i]))
            {
                if (p.Key == "X")
                {
                    X = double.Parse(p.Value.ToString());
                }
                if (p.Key == "Y")
                {
                    Y = double.Parse(p.Value.ToString());
                }


            }
            Stra = new MapPoint(X, Y);
            //如果在总数之内
            if (i + 1 < JsData.DataCount)
            {
                foreach (var p in ((System.Json.JsonObject)JsValue[i + 1]))
                {
                    if (p.Key == "X")
                    {
                        XX = double.Parse(p.Value.ToString());
                    }
                    if (p.Key == "Y")
                    {
                        YY = double.Parse(p.Value.ToString());
                    }
                }
                End = new MapPoint(XX, YY);
            }
            else
            {
                End = new MapPoint(X, Y);

            }

            SPoint = Stra;
            EPoint = End;


        }

        /// <summary>
        /// 画线
        /// </summary>
        /// <param name="p">当前的点索引</param>
        /// <param name="Star">起点</param>
        /// <param name="End">结束点</param>
        void 画线(int p, MapPoint Star, MapPoint End)
        {
            if (!开始画点了)
            {
                return;

            }
            //点 集合
            ESRI.ArcGIS.Client.Geometry.PointCollection PointColl = new ESRI.ArcGIS.Client.Geometry.PointCollection();

            PointColl.Add(Star);
            PointColl.Add(End);

            //创建一个线
            ESRI.ArcGIS.Client.Geometry.Polyline polyLine = new ESRI.ArcGIS.Client.Geometry.Polyline();
            //将点添加到线
            polyLine.Paths.Add(PointColl);
            //添加图层到集合
            Graphic grap = new Graphic()
            {
                Geometry = polyLine,
                Symbol = GetSymbol(polyLine, Colors.Blue)

            };
            GraphicLayer.Graphics.Add(grap);
            graphicManager.Add(grap);
        }


        /// <summary>
        /// 根据几何要素取得对应的渲染符号
        /// </summary>
        /// <param name="ge"></param>
        /// <returns></returns>
        public Symbol GetSymbol(ESRI.ArcGIS.Client.Geometry.Geometry ge, Color color)
        {
            if (ge is MapPoint)
                return new SimpleMarkerSymbol()
                {
                    Color = new SolidColorBrush(color),
                    Size = 10,
                    Style = ESRI.ArcGIS.Client.Symbols.SimpleMarkerSymbol.SimpleMarkerStyle.Circle
                };
            else if (ge is ESRI.ArcGIS.Client.Geometry.Polyline)
                return new LineSymbol() { Color = new SolidColorBrush(color), Width = 3 };
            else if (ge is ESRI.ArcGIS.Client.Geometry.Polygon
                     || ge is ESRI.ArcGIS.Client.Geometry.Envelope)
            {
                Symbol MySm = new SimpleFillSymbol()
                {
                    BorderBrush = new SolidColorBrush(color) { },
                    BorderThickness = 3,
                    Fill = new SolidColorBrush(Colors.Green) { Opacity = 0.5 }
                };
                return MySm;
            }
            return null;
        }

        #endregion

        /// <summary>
        /// 加载地图完成
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ArcGISDynamicMapServiceLayer_Initialized(object sender, EventArgs e)
        {

          ///得到当前的数据
            JsData.GetDate(new Uri(System.Windows.Browser.HtmlPage.Document.DocumentUri.Scheme+"://"+System.Windows.Browser.HtmlPage.Document.DocumentUri.Host+":"+System.Windows.Browser.HtmlPage.Document.DocumentUri.Port+"/LineBackJsonDataSource.txt?" + Guid.NewGuid().ToString()));


            //全线路
            MapObj.ZoomTo(((ESRI.ArcGIS.Client.Layer)MapObj.Layers[0]).FullExtent);



            return;

        }



        /// <summary>
        /// 失败处理事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ArcGISTiledMapServiceLayer_InitializationFailed(object sender, EventArgs e)
        {
            System.Windows.MessageBox.Show(((Layer)sender).InitializationFailure.Message);
        }

        int p = 0;

        /// <summary>
        /// 定义一个 Timer
        /// </summary>
        System.Windows.Threading.DispatcherTimer timer = new System.Windows.Threading.DispatcherTimer();

        /// <summary>
        /// 进度条点击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void prog_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
        {
            //清空所有的数据
            GraphicLayer.Graphics.Clear();

            Rec.Visibility =  Visibility.Visible;
            RecElementLayer.Visibility = Visibility.Collapsed;

            //重新设定指针
             p = 0;

             //设定最大值
             silder.Maximum = JsData.DataCount - 1;
            

            //开始画点
            GraphicLayer.Dispatcher.BeginInvoke(new Action(() =>
            {

                try
                {
                    //删除一个事件
                    timer.Tick -= new EventHandler(timer_Tick);
                }
                catch { 
                    
                }


                开始画点了 = true;
                timer.Interval = TimeSpan.FromMilliseconds(80);
                timer.Tick += new EventHandler(timer_Tick);
                timer.Start();
            }));

        }

        void timer_Tick(object sender, EventArgs e)
        {



            //如果记录回放完成
            if (JsData.DataCount == p)
            {
                if (timer != null)
                {
                    timer.Stop();
                    开始画点了 = false;
                    System.Windows.MessageBox.Show("回放完成");

                    RecElementLayer.Visibility = Visibility.Visible;
                    Rec.Visibility = Visibility.Collapsed;
                    
                    p = 0;
                }

                return;
            }

            #region 生成随机画线
            //画线(
            //    new MapPoint(121.587785,
            //        double.Parse("31."+ System.Text.RegularExpressions.Regex.Match(Guid.NewGuid().ToString(), @"\d{1,6}").Value)
            //        ), new MapPoint(
            //    double.Parse("121."+
            //System.Text.RegularExpressions.Regex.Match(Guid.NewGuid().ToString(), @"\d{1,6}").Value
            //)
            //    , 31.0880583333333));

            #endregion
            画单条线的方法(p);
            ///邦定当前的进度
           // silder.Value = p;
            p++;
        }

        /// <summary>
        ///值改变事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void silder_ValueChanged(object sender, RoutedPropertyChangedEventArgs<double> e)
        {
            //看看值变化的方式
            //由小到大
            //由大到小
            if (!开始画点了)
            {
                开始画点了 = true;
            }
            //由小到大
            if (e.NewValue > e.OldValue)
            {
                画单条线的方法(int.Parse(e.NewValue.ToString("f0")));
                tt.Text = e.NewValue.ToString("f0");
            }

            //由大到小
            if (e.OldValue > e.NewValue)
            {
                
                //重新调整画线进度
                tt.Text = e.NewValue.ToString("f0");

                for(int k= int.Parse( e.NewValue.ToString("f0")); k<=e.OldValue;k++)
                {
                    删除单条线的方法(k);
                }
            }



        }

        /// <summary>
        /// 当按键弹起
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void silder_MouseLeftButtonUp(object sender, MouseButtonEventArgs e)
        {
            画单条线的方法(int.Parse(silder.Value.ToString("f0")));
        }

        #region 站点初始化数据 进行画站点试用

        /// <summary>
        /// 画图图层
        /// </summary>
        protected GraphicsLayer gLayer
        {

            get { return MapObj.Layers["线路图层"] as GraphicsLayer; }
        }

        /// <summary>
        /// 单击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Button_Click(object sender, RoutedEventArgs e)
        {



            #region 初始化站点数据

            var stations = 测试用的站点数据();

            DrawRouteLine(stations);


            #endregion

            //添加自定义地图
            if (MapObj.Layers.Count <= 1)
            {
                MapObj.ZoomTo(new ESRI.ArcGIS.Client.Geometry.Envelope(
                    new MapPoint(stations.First().F_LONGITUDE, stations.First().F_LATITUDE),
                    new MapPoint(stations.Last().F_LONGITUDE, stations.Last().F_LATITUDE)

                    ));
            }
        }

        #region 测试用的代码

        List<TBL_STATION> 测试用的站点数据()
        {
            #region 测试用XML数据
            StringBuilder strSql = new StringBuilder();
            strSql.AppendLine("<?xml version=\"1.0\" encoding=\"utf-8\"?> ");
            strSql.AppendLine("<ArrayOfTBL_STATION xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_STATION_TYPE>1</UI_STATION_TYPE> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>周东路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>1</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>04510011</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.35272</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.05284</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    UI_DIRECTION ");
            strSql.AppendLine("    <SZ_NAME>塘东社区中心 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>2</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>04510012</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.35241</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.05499</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>周东路纬二路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>3</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>04510013</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.35204</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.05747</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>周东路周祝公路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>4</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>04510014</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.35137</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.06192</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>周东路祝家港路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>5</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>04510015</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.35060</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.06713</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>周东路年家浜东路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>6</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>04510016</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.35004</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.06938</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>周东路关岳路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>7</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>04510017</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.34878</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.07284</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.34783</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.07538</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>周东路川周公路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>8</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>04510019</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.34741</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.07495</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>川周公路文康路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>9</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100110</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.34622</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.07377</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.34461</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.07295</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>川周公路康沈公路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>10</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100112</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.34315</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.07295</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.34274</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.07298</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>公元新村 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>11</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100114</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.34267</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.07367</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.34262</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.07451</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>营房桥 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>12</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100116</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.34232</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.07655</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.34209</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.08072</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.34145</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.08225</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>康桥文化中心 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>13</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100119</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.34027</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.08221</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>秀沿路沪南路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>14</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100120</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.33792</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.08211</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.33802</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.08419</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>秀沿路秀康路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>15</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100122</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.33797</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.08511</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.33793</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.08873</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>沪南路康桥路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>16</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100124</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.33757</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.09008</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>长征 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>17</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100125</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.33638</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.09387</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.33607</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.09488</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>沪南路御桥路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>18</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100127</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.33589</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.09586</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.33543</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.09902</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>上海农产品市场 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>19</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100129</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.33415</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.10211</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>陈家桥 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>20</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100130</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.33230</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.10575</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.33142</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.10873</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>莲溪 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>21</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100132</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.33051</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.11063</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.32909</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.11440</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>北蔡 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>22</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100134</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.32850</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.11526</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.32574</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.12115</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>花木 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>23</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100136</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.32427</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.12329</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.32281</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.12477</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>浦建路锦绣路锦绣路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>24</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100138</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.32114</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.12551</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31849</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.12590</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>易初莲花 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>25</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100140</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31482</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.12599</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31286</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.12606</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>东方路蓝村路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>26</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100142</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31363</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.12740</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31487</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.12992</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>东方路峨山路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>27</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100144</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31507</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13091</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31512</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13189</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31491</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13303</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31468</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13372</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31339</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13686</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>潍坊路崂山路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>28</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100149</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31245</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13657</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31175</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13635</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31075</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13877</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>崂山路张杨路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>29</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100152</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31025</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13861</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.30292</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13578</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.30150</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13510</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.29925</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13464</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.29764</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13390</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.29693</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13377</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.29407</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13444</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.29092</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13429</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.29041</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13415</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>老西门 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>30</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100161</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.28895</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13310</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.28823</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13273</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.28689</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13252</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.28656</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13301</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.28621</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13426</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.28556</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13651</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>西藏南路宁海东路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>31</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100167</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.28457</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13796</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>人民广场（福州路） </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>32</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100168</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.28330</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.14002</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.28028</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13809</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.27936</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13979</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.27969</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.14003</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_STATION_TYPE>2</UI_STATION_TYPE> ");
            strSql.AppendLine("    <UI_DIRECTION>1</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>南京西路西藏中路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>33</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100172</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.27985</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.14038</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_STATION_TYPE>3</UI_STATION_TYPE> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>南京西路西藏中路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>34</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100173</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.27987</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.14041</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.28046</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.14115</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.28233</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.14142</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>人民广场（福州路） </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>35</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100176</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.28328</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13994</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>西藏南路宁海东路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>36</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100177</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.28488</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13746</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.28552</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13653</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.28624</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13392</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.28653</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13287</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.28688</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13246</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.28828</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13266</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>老西门 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>37</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100183</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.28862</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13288</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.29048</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13409</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.29129</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13426</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.29401</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13439</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.29691</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13370</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.29764</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13382</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.29912</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13454</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.30182</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13513</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.30303</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13574</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>崂山路张杨路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>38</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100192</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31040</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13865</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31073</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13877</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>崂山路潍坊路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>39</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100194</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31163</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13648</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>浦电路崂山路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>40</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100195</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31288</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13316</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31463</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13373</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31487</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13284</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31507</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13189</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>东方路峨山路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>41</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>045100199</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31498</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.13087</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31483</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.12996</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>东方路蓝村路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>42</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>0451001101</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31363</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.12750</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31286</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.12609</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>易初莲花 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>43</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>0451001103</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31483</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.12597</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.31853</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.12582</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>浦建路锦绣路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>44</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>0451001105</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.32033</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.12563</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.32226</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.12511</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.32368</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.12408</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>花木 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>45</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>0451001108</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.32423</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.12330</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.32574</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.12113</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>北蔡 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>46</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>0451001110</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.32871</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.11502</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>莲溪 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>47</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>0451001111</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.33059</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.11047</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.33138</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.10861</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>陈家桥 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>48</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>0451001113</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.33225</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.10573</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>上海农产品市场 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>49</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>0451001114</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.33457</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.10133</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.33543</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.09915</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>沪南路御桥路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>50</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>0451001116</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.33588</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.09589</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.33603</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.09489</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>长征 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>51</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>0451001118</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.33630</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.09386</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>沪南路康桥路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>52</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>0451001119</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.33753</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.09005</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.33784</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.08883</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>秀沿路秀康路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>53</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>0451001121</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.33792</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.08507</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.33796</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.08419</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>秀沿路沪南路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>54</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>0451001123</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.33790</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.08209</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>康桥文化中心 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>55</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>0451001124</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.34022</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.08221</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.34148</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.08223</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.34206</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.08079</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>营房桥 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>56</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>0451001127</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.34233</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.07653</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.34269</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.07453</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>公元新村 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>57</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>0451001129</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.34274</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.07376</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.34280</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.07302</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>川周公路康沈公路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>58</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>0451001131</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.34332</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.07301</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.34462</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.07294</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>川周公路文康路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>59</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>0451001133</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.34623</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.07376</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>周东路川周公路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>60</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>0451001134</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.34746</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.07509</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <adjust> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <F_LONGITUDE>121.34780</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.07541</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </adjust> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>周东路关岳路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>61</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>0451001136</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.34874</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.07287</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>周东路年家浜东路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>62</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>0451001137</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.35000</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.06952</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>周东路祝家港路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>63</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>0451001138</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.35046</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.06785</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>周东路周祝公路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>64</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>0451001139</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.35134</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.06191</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>周东路纬二路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>65</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>0451001140</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.35204</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.05765</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>塘东社区中心 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>66</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>0451001141</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.35240</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.05512</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("  <TBL_STATION> ");
            strSql.AppendLine("    <UI_STATION_TYPE>4</UI_STATION_TYPE> ");
            strSql.AppendLine("    <UI_DIRECTION>2</UI_DIRECTION> ");
            strSql.AppendLine("    <SZ_NAME>周东路 </SZ_NAME> ");
            strSql.AppendLine("    <UI_STATION_INDEX>67</UI_STATION_INDEX> ");
            strSql.AppendLine("    <SZ_INTER_ID>0451001142</SZ_INTER_ID> ");
            strSql.AppendLine("    <F_LONGITUDE>121.35271</F_LONGITUDE> ");
            strSql.AppendLine("    <F_LATITUDE>31.05298</F_LATITUDE> ");
            strSql.AppendLine("    <SZ_REMARK>50</SZ_REMARK> ");
            strSql.AppendLine("  </TBL_STATION> ");
            strSql.AppendLine("</ArrayOfTBL_STATION> ");
            #endregion

            #region 2.0数据库中的站点数据
            string x = StationData.str;
            #endregion



            System.Xml.Serialization.XmlSerializer xmlSerialize = new System.Xml.Serialization.XmlSerializer(typeof(nodes));

            System.IO.StringWriter sw = new System.IO.StringWriter();
            xmlSerialize.Serialize(sw, new nodes(){ 
             new TBL_STATION(){
              SZ_REMARK="sdfsdfsdf",
             }
            });

            nodes obj = (nodes)xmlSerialize.Deserialize(new System.IO.StringReader(x.ToString()));

            return obj;
        }
        #endregion

        #region 处理画线的方法
        #region 子类可见的方法

        #region 定义样式 Symbols

        #region XAML原素说明 用于邦定到界面标识里的原素
        //<esriSymbols:PictureMarkerSymbol   x:Key="StationUpSite"        Source="{Binding ElementName=StationUpSiteStyle,Path=Source}"/>
        //<esriSymbols:PictureMarkerSymbol   x:Key="StationDownSite"      Source="{Binding ElementName=StationDownSiteStyle,Path=Source}"/>
        //<esriSymbols:PictureMarkerSymbol   x:Key="RouteBusCommon"       Source="{Binding ElementName=RouteBusCommonStyle,Path=Source}"/>
        //<esriSymbols:PictureMarkerSymbol   x:Key="RouteBusOffLine"      Source="{Binding ElementName=RouteBusOffLineStyle,Path=Source}"/>
        //<esriSymbols:PictureMarkerSymbol   x:Key="RouteBusError"        Source="{Binding ElementName=RouteBusErrorStyle,Path=Source}"/>
        //<esriSymbols:PictureMarkerSymbol   x:Key="DriverRequest"        Source="{Binding ElementName=DriverRequestStyle,Path=Source}"/>
        //<esriSymbols:SimpleLineSymbol      x:Key="RouteLineSymbol"        Color="{Binding ElementName=RouteLineSymbolStyle,Path=Stroke}" Width="4" Style="Solid" />
        #endregion

        /// <summary>
        /// 上行线路Symbol 线路颜色
        /// </summary>
        LineSymbol routeLineUpSymbol = null;

        /// <summary>
        /// 上行线路Symbol 线路颜色
        /// </summary>
        protected ESRI.ArcGIS.Client.Symbols.LineSymbol RouteLineUpSymbol
        {
            get
            {
                if (routeLineUpSymbol == null)
                {
                    routeLineUpSymbol = new LineSymbol();

                    //邦定  属性 
                    routeLineUpSymbol.SetValue(LineSymbol.ColorProperty, RouteLineUpSymbolStyle.Stroke);
                    routeLineUpSymbol.SetValue(LineSymbol.WidthProperty, RouteLineUpSymbolStyle.Height);
                }
                return routeLineUpSymbol;
            }
        }


        /// <summary>
        /// 下行线路Symbol 线路颜色
        /// </summary>
        LineSymbol routeLineDownSymbol = null;

        /// <summary>
        /// 下行线路Symbol 线路颜色
        /// </summary>
        protected ESRI.ArcGIS.Client.Symbols.LineSymbol RouteLineDownSymbol
        {
            get
            {
                if (routeLineDownSymbol == null)
                {
                    routeLineDownSymbol = new LineSymbol();

                    //邦定  属性 
                    routeLineDownSymbol.SetValue(LineSymbol.ColorProperty, RouteLineDownSymbolStyle.Stroke);
                    routeLineDownSymbol.SetValue(LineSymbol.WidthProperty, RouteLineDownSymbolStyle.Height);
                }
                return routeLineDownSymbol;
            }
        }
        /// <summary>
        /// 下行站点图标 PictureMarkerSymbol
        /// </summary>
        PictureMarkerSymbol stationDownSite = null;
        /// <summary>
        /// 下行站点图标 PictureMarkerSymbol
        /// </summary>
        public PictureMarkerSymbol StationDownSite
        {
            get
            {

                if (stationDownSite == null)
                {
                    stationDownSite = new PictureMarkerSymbol();

                    //邦定  属性 
                    stationDownSite.SetValue(PictureMarkerSymbol.WidthProperty, StationDownSiteStyle.Width);
                    stationDownSite.SetValue(PictureMarkerSymbol.HeightProperty, StationDownSiteStyle.Height);
                    stationDownSite.SetValue(PictureMarkerSymbol.SourceProperty, StationDownSiteStyle.Source);
                    //stationDownSite.SetValue(PictureMarkerSymbol.OffsetXProperty, 10.0);
                    //stationDownSite.SetValue(PictureMarkerSymbol.OffsetYProperty, 10.0);
                }
                return stationDownSite;
            }
        }



        /// <summary>
        /// 上行站点图标 PictureMarkerSymbol
        /// </summary>
        PictureMarkerSymbol stationUpSite = null;

        /// <summary>
        /// 上行站点图标 PictureMarkerSymbol
        /// </summary>
        public PictureMarkerSymbol StationUpSite
        {
            get
            {
                if (stationUpSite == null)
                {
                    stationUpSite = new PictureMarkerSymbol();

                    //邦定  属性 
                    stationUpSite.SetValue(PictureMarkerSymbol.WidthProperty, StationUpSiteStyle.Width);
                    stationUpSite.SetValue(PictureMarkerSymbol.HeightProperty, StationUpSiteStyle.Height);
                    stationUpSite.SetValue(PictureMarkerSymbol.SourceProperty, StationUpSiteStyle.Source);
                    //stationUpSite.SetValue(PictureMarkerSymbol.OffsetXProperty, 10.0);
                    //stationUpSite.SetValue(PictureMarkerSymbol.OffsetYProperty, 10.0);
                }
                return stationUpSite;
            }
        }

        /// <summary>
        /// 离线车辆图标 PictureMarkerSymbol
        /// </summary>
        PictureMarkerSymbol routeBusOffLine = null;

        /// <summary>
        /// 离线车辆图标 PictureMarkerSymbol
        /// </summary>
        public PictureMarkerSymbol RouteBusOffLine
        {
            get
            {
                if (routeBusOffLine == null)
                {
                    routeBusOffLine = new PictureMarkerSymbol();

                    //邦定属性 
                    routeBusOffLine.SetValue(PictureMarkerSymbol.WidthProperty, RouteBusOffLineStyle.Width);
                    routeBusOffLine.SetValue(PictureMarkerSymbol.HeightProperty, RouteBusOffLineStyle.Height);
                    routeBusOffLine.SetValue(PictureMarkerSymbol.SourceProperty, RouteBusOffLineStyle.Source);

                }
                return routeBusOffLine;
            }
        }



        /// <summary>
        /// 一般车辆图标 PictureMarkerSymbol
        /// </summary>
        PictureMarkerSymbol routeBusCommon = null;

        /// <summary>
        /// 一般车辆图标 PictureMarkerSymbol
        /// </summary>
        public PictureMarkerSymbol RouteBusCommon
        {
            get
            {
                if (routeBusCommon == null)
                {
                    routeBusCommon = new PictureMarkerSymbol();

                    //邦定属性 
                    routeBusCommon.SetValue(PictureMarkerSymbol.WidthProperty, RouteBusCommonStyle.Width);
                    routeBusCommon.SetValue(PictureMarkerSymbol.HeightProperty, RouteBusCommonStyle.Height);
                    routeBusCommon.SetValue(PictureMarkerSymbol.SourceProperty, RouteBusCommonStyle.Source);

                }
                return routeBusCommon;
            }
        }

        /// <summary>
        /// 异常车辆图标 PictureMarkerSymbol
        /// </summary>
        PictureMarkerSymbol routeBusError = null;

        /// <summary>
        /// 异常车辆图标 PictureMarkerSymbol
        /// </summary>
        public PictureMarkerSymbol RouteBusError
        {
            get
            {
                if (routeBusError == null)
                {
                    routeBusError = new PictureMarkerSymbol();

                    //邦定属性 
                    routeBusError.SetValue(PictureMarkerSymbol.WidthProperty, RouteBusErrorStyle.Width);
                    routeBusError.SetValue(PictureMarkerSymbol.HeightProperty, RouteBusErrorStyle.Height);
                    routeBusError.SetValue(PictureMarkerSymbol.SourceProperty, RouteBusErrorStyle.Source);

                }
                return routeBusError;
            }
        }

        /// <summary>
        /// 驾驭员请求图标 PictureMarkerSymbol
        /// </summary>
        PictureMarkerSymbol driverRequest = null;

        /// <summary>
        /// 驾驭员请求图标 PictureMarkerSymbol
        /// </summary>
        public PictureMarkerSymbol DriverRequest
        {
            get
            {

                if (driverRequest == null)
                {
                    driverRequest = new PictureMarkerSymbol();

                    //邦定属性 
                    driverRequest.SetValue(PictureMarkerSymbol.WidthProperty, DriverRequestStyle.Width);
                    driverRequest.SetValue(PictureMarkerSymbol.HeightProperty, DriverRequestStyle.Height);
                    driverRequest.SetValue(PictureMarkerSymbol.SourceProperty, DriverRequestStyle.Source);

                }

                return driverRequest;
            }
        }



        #endregion

        #region 创建站点的方法
        /// <summary>
        /// 创建站点 到指定的图层
        /// </summary>
        /// <param name="gLayer">GraphicsLayer 图层对像</param>
        /// <param name="StationPoint">站点 MapPoint</param>
        /// <param name="StationName">站点名称</param>
        /// <param name="StationType">站点类型 1上行,2下行</param>
        /// <param name="StationSummary">站点说明</param>
        void CreateStation(GraphicsLayer gLayer, MapPoint StationPoint, int StationType, string StationName, string StationSummary)
        {

            #region 处理站点类型

            //站点 Symbol
            Symbol StationSymbol = StationDownSite;
            ///站点默认背景
            string ColorString = "#FFE9FFBE";
            //放大比例 上行 1 下行-1
            int ScaleY = 1;
            ///角度 上行 45 下行135
            int Angle = 45;
            //RenderTransformOrigin属性 上行0,0 下行 0,1
            string RenderTransformOrigin = "0,0";

            ///处理
            string Margin = StationDownSite.Height * 1.5 + ",0,0,0";

            //处理不同类型的参数
            if (StationType == 1)
            {
                StationSymbol = StationUpSite;
                ColorString = "#FFE9FFBE";
                //放大比例 上行 1 下行-1
                ScaleY = 1;
                ///角度 上行 45 下行-45
                Angle = 45;
                RenderTransformOrigin = "0,0";
            }
            else
            {
                StationSymbol = StationDownSite;
                ColorString = "#FFFFD37F";
                //放大比例 上行 1 下行-1
                ScaleY = -1;
                ///角度 上行 45 下行135
                Angle = 135;
                RenderTransformOrigin = "0,1";
                Margin = "0,0,0,0";
            }

            #endregion

            //样式模板
            StringBuilder strStationTextControlTemplate = new StringBuilder();
            strStationTextControlTemplate.AppendLine("                <ControlTemplate x:Key='TextSymbolStyle' xmlns='http://schemas.microsoft.com/winfx/2006/xaml/presentation' xmlns:x='http://schemas.microsoft.com/winfx/2006/xaml'> ");
            strStationTextControlTemplate.AppendLine("                    <Grid x:Name='RootElement' Margin='{6}' ToolTipService.ToolTip='{2}'  RenderTransformOrigin='{5}' > ");//站点描述写在这里  RenderTransformOrigin属性 上行0,0 下行 0,1
            strStationTextControlTemplate.AppendLine("                          <Grid.RenderTransform> ");
            strStationTextControlTemplate.AppendLine("                              <TransformGroup> ");
            strStationTextControlTemplate.AppendLine("                                  <ScaleTransform ScaleY='{3}'/> ");//上行 1 下行-1
            strStationTextControlTemplate.AppendLine("                                  <SkewTransform/> ");
            strStationTextControlTemplate.AppendLine("                                  <RotateTransform Angle='{4}'/> ");//上行 45 下行135
            strStationTextControlTemplate.AppendLine("                                  <TranslateTransform/> ");
            strStationTextControlTemplate.AppendLine("                              </TransformGroup> ");
            strStationTextControlTemplate.AppendLine("                          </Grid.RenderTransform> ");
            strStationTextControlTemplate.AppendLine("                        <Border x:Name='Border' Opacity='1' Background='{0}'  BorderBrush='Black' CornerRadius='1' BorderThickness='1'> ");//#FFE9FFBE 框子背景色写在这里
            strStationTextControlTemplate.AppendLine("                            <TextBlock Text='{1}'/> ");//站点名字写在这里
            strStationTextControlTemplate.AppendLine("                        </Border> ");
            strStationTextControlTemplate.AppendLine("                    </Grid> ");
            strStationTextControlTemplate.AppendLine("                </ControlTemplate> ");






            Graphic PointGraphicStation = new Graphic();
            PointGraphicStation.Geometry = StationPoint;
            PointGraphicStation.Symbol = StationSymbol;


            //创建Text对像
            Graphic TextGraphicStation = new Graphic();
            TextGraphicStation.Geometry = StationPoint;
            TextGraphicStation.Symbol = new ESRI.ArcGIS.Client.Symbols.TextSymbol
            {
#if SILVERLIGHT
                ControlTemplate = System.Windows.Markup.XamlReader.Load(string.Format(strStationTextControlTemplate.ToString(), ColorString, StationName, StationSummary, ScaleY, Angle, RenderTransformOrigin, Margin)) as ControlTemplate
#endif

#if WPF
                ControlTemplate = System.Windows.Markup.XamlReader.Parse(string.Format(strStationTextControlTemplate.ToString(), ColorString, StationName,StationSummary,ScaleX,Angle,RenderTransformOrigin,Margin)) as ControlTemplate
#endif
            };

            gLayer.Graphics.Add(TextGraphicStation);
            gLayer.Graphics.Add(PointGraphicStation);
        }



        #endregion

        /// <summary>
        /// 画线路ID
        /// </summary>
        /// <param name="Stations">线路站点数据集合</param>
        protected void DrawRouteLine(System.Collections.Generic.IEnumerable<TBL_STATION> Stations)
        {
            #region 画上行线
            ///创建点集合 用于添加到线中 上行线
            ESRI.ArcGIS.Client.Geometry.PointCollection pcUp = new ESRI.ArcGIS.Client.Geometry.PointCollection();
            ///画站点数据 上行
            foreach (TBL_STATION item in Stations.Where(p => p.UI_DIRECTION == 1))
            {
                pcUp.Add(new ESRI.ArcGIS.Client.Geometry.MapPoint(item.F_LONGITUDE, item.F_LATITUDE));
            }

            //画线的方法 上行
            DrawPoint(pcUp, gLayer, RouteLineUpSymbol);

            #endregion


            #region 画下行线

            ///创建点集合 用于添加到线中 下行线
            ESRI.ArcGIS.Client.Geometry.PointCollection pcDown = new ESRI.ArcGIS.Client.Geometry.PointCollection();
            ///画站点数据 下行
            foreach (TBL_STATION item in Stations.Where(p => p.UI_DIRECTION == 2))
            {
                pcDown.Add(new ESRI.ArcGIS.Client.Geometry.MapPoint(item.F_LONGITUDE, item.F_LATITUDE));
            }
            //画线的方法 上行
            DrawPoint(pcDown, gLayer, RouteLineDownSymbol);

            #endregion



            ///画站点数据
            foreach (TBL_STATION item in Stations)
            {

                CreateStation(gLayer, new ESRI.ArcGIS.Client.Geometry.MapPoint(item.F_LONGITUDE, item.F_LATITUDE), item.UI_DIRECTION, item.SZ_NAME, item.SZ_NAME);
            }
        }

        /// <summary>
        /// 画线的方法
        /// </summary>
        /// <param name="mapPointCollection">地图的点集合</param>
        /// <param name="Symbol">图标样式</param>
        /// <param name="layer">图层</param>
        protected void DrawPoint(ESRI.ArcGIS.Client.Geometry.PointCollection mapPointCollection, GraphicsLayer layer, ESRI.ArcGIS.Client.Symbols.Symbol Symbol)
        {
            //画线
            ESRI.ArcGIS.Client.Geometry.Polyline polyline = new ESRI.ArcGIS.Client.Geometry.Polyline();
            polyline.Paths.Add(mapPointCollection);
            ///创建一个图的对像
            Graphic LineGraphic = new Graphic();
            
            LineGraphic.Geometry = polyline;
            LineGraphic.Symbol =new LineSymbol();
            gLayer.Graphics.Add(LineGraphic);
        }


        #endregion
        #endregion

        #region 测试用的代码实体类完成协议后可以删除


        public class nodes : List<TBL_STATION>
        {

        }

        /// <summary>
        /// RET_GET_ROUTE_STATION_LIST  返回 线路站点列表 信息 数据 实体
        /// </summary>
        public class TBL_STATION : System.ComponentModel.INotifyPropertyChanged
        {
            private long _UBI_LOGIC_ID;
            /// <summary>
            /// 流水号(long)UInt64
            /// </summary>
            public long UBI_LOGIC_ID
            {
                get { return _UBI_LOGIC_ID; }
                set
                {
                    _UBI_LOGIC_ID = value;
                    OnPropertyChanged("UBI_LOGIC_ID");
                }
            }


            private long _UBI_ROUTE_ID;
            /// <summary>
            /// 线路流水号字段(long)
            /// </summary>
            public long UBI_ROUTE_ID
            {
                get { return _UBI_ROUTE_ID; }
                set
                {
                    _UBI_ROUTE_ID = value;
                    OnPropertyChanged("UBI_ROUTE_ID");
                }
            }


            private string _szInterId;
            /// <summary>
            /// 站点内部编号(string)char[20]
            /// </summary>
            public string szInterId
            {
                get { return _szInterId; }
                set
                {
                    _szInterId = value;
                    OnPropertyChanged("szInterId");
                }
            }


            private int _UI_STATION_TYPE;
            /// <summary>
            ///站点类型(int)uint站点类型
            ///1.上行起点
            ///2.上行终点
            ///3.下行起点
            ///4.下行终点
            ///0.其他点
            /// </summary>
            public int UI_STATION_TYPE
            {
                get { return _UI_STATION_TYPE; }
                set
                {
                    _UI_STATION_TYPE = value;
                    OnPropertyChanged("UI_STATION_TYPE");
                }
            }


            private int _UI_INDEX;
            /// <summary>
            /// 点序号(int)uint
            /// </summary>
            public int UI_INDEX
            {
                get { return _UI_INDEX; }
                set
                {
                    _UI_INDEX = value;
                    OnPropertyChanged("UI_INDEX");
                }
            }


            private int _UI_STATION_INDEX;
            /// <summary>
            /// 站序号(int)uint
            /// </summary>
            public int UI_STATION_INDEX
            {
                get { return _UI_STATION_INDEX; }
                set
                {
                    _UI_STATION_INDEX = value;
                    OnPropertyChanged("UI_STATION_INDEX");
                }
            }


            private int _UI_DIRECTION;
            /// <summary>
            /// 方向(int)方向（1:上行；2:下行
            /// </summary>
            public int UI_DIRECTION
            {
                get { return _UI_DIRECTION; }
                set
                {
                    _UI_DIRECTION = value;
                    OnPropertyChanged("UI_DIRECTION");
                }
            }


            private float _F_DISTANCE;
            /// <summary>
            /// 距离(float)
            /// </summary>
            public float F_DISTANCE
            {
                get { return _F_DISTANCE; }
                set
                {
                    _F_DISTANCE = value;
                    OnPropertyChanged("F_DISTANCE");
                }
            }


            private string _SZ_NAME;
            /// <summary>
            /// 站名(string)char[50];
            /// </summary>
            public string SZ_NAME
            {
                get { return _SZ_NAME; }
                set
                {
                    _SZ_NAME = value;
                    OnPropertyChanged("SZ_NAME");
                }
            }


            private double _F_LONGITUDE;
            /// <summary>
            /// 经度(double)float
            /// </summary>
            public double F_LONGITUDE
            {
                get { return _F_LONGITUDE; }
                set
                {
                    _F_LONGITUDE = value;
                    OnPropertyChanged("F_LONGITUDE");
                }
            }


            private double _F_LATITUDE;
            /// <summary>
            /// 纬度(double)float
            /// </summary>
            public double F_LATITUDE
            {
                get { return _F_LATITUDE; }
                set
                {
                    _F_LATITUDE = value;
                    OnPropertyChanged("F_LATITUDE");
                }
            }


            private string _SZ_POSITION_DESCRIPTION;
            /// <summary>
            /// 站点描述(string)char[100];
            /// </summary>
            public string SZ_POSITION_DESCRIPTION
            {
                get { return _SZ_POSITION_DESCRIPTION; }
                set
                {
                    _SZ_POSITION_DESCRIPTION = value;
                    OnPropertyChanged("SZ_POSITION_DESCRIPTION");
                }
            }


            private string _T_FIRST_TIME;
            /// <summary>
            /// 首班时刻(string)范围HH:mm格式:yyyy-MM-dd HH:mm:ss
            /// </summary>
            public string T_FIRST_TIME
            {
                get { return _T_FIRST_TIME; }
                set
                {
                    _T_FIRST_TIME = value;
                    OnPropertyChanged("T_FIRST_TIME");
                }
            }


            private string _T_LAST_TIME;
            /// <summary>
            /// 末班时刻(string)范围HH:mm格式:yyyy-MM-dd HH:mm:ss
            /// </summary>
            public string T_LAST_TIME
            {
                get { return _T_LAST_TIME; }
                set
                {
                    _T_LAST_TIME = value;
                    OnPropertyChanged("T_LAST_TIME");
                }
            }


            private bool _B_ALLOW_BACK;
            /// <summary>
            /// 允许调头(bool)
            /// </summary>
            public bool B_ALLOW_BACK
            {
                get { return _B_ALLOW_BACK; }
                set
                {
                    _B_ALLOW_BACK = value;
                    OnPropertyChanged("B_ALLOW_BACK");
                }
            }


            private string _SZ_REMARK;
            /// <summary>
            /// 备注(string)char[50]
            /// </summary>
            public string SZ_REMARK
            {
                get { return _SZ_REMARK; }
                set
                {
                    _SZ_REMARK = value;
                    OnPropertyChanged("SZ_REMARK");
                }
            }




            #region INotifyPropertyChanged 成员

            public event System.ComponentModel.PropertyChangedEventHandler PropertyChanged;
            /// <summary>
            /// 实现 属性改变的方法
            /// </summary>
            /// <param name="propertyName"></param>
            protected virtual void OnPropertyChanged(string propertyName)
            {
                if (this.PropertyChanged != null)
                {
                    this.PropertyChanged(this, new System.ComponentModel.PropertyChangedEventArgs(propertyName));
                }
            }


            #endregion
        }
        #endregion
        #endregion



        #region 公开的脚本方法


        #endregion
    }

    public class TextConvert : System.Windows.Data.IValueConverter
    {
    

        #region IValueConverter 成员

        public object Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
        {
            

            return value.ToString();
        }

        public object ConvertBack(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
        {
            return double.Parse(value.ToString());
        }

        #endregion
    }



}







